<%@ page import="java.sql.*,java.util.*"%>
<html>

<head>
	<title>Header</title>	
    <style type="text/css">
     A:link 
	 {
     	text-decoration: none;
     	color:yellow;
     	font-family: verdana;
     	
		font-size: 9pt;
     }
     A:visited 
	 {
     	text-decoration:none;
     	font-family: verdana;
     	color: yellow;
     	
        font-size: 9pt;
     }
     A:hover 
	 {
     	text-decoration:none;
     	color: pink;
     	font-family: verdana;

        font-size: 9pt;
     }
</style>

    <meta name="Microsoft Theme" content="strtedge 001">

</head>
<body topmargin=0 leftmargin=0 background="strbkgde.gif" bgcolor="#FFFFFF" text="#000000" link="#660000" vlink="#003399" alink="#999933">
<!--mstheme--><font face="Arial, Helvetica">
<img border="0" src="Onlineedu5.jpg" width="789" height="61">
<!--mstheme--></font>
<TABLE bgcolor="#006699" border=0  width=790>
<tr align="right" align="center">	
	<td align="center" width="782" valign="center">
    <!--mstheme--><font face="Arial, Helvetica">
    <font color="#FFFFA4" align="center">
<b>Fee Information</b>&nbsp;&nbsp;<b> 
	</font>
 
    <!--mstheme--></font>
 
	</td>
	  <td width="6%" nowrap bordercolor="#006699" bgcolor="#006699" height="1"><!--mstheme--><font face="Arial, Helvetica"><div align="right"><strong><a href="AboutUs.htm"><font color="#FFFFA4">Home</font></a><font color="#FFFFA4">|
          </font></strong><font size="1" color="#FFFFA4"><b><a href="student.htm">Back</a></b></font></div><!--mstheme--></font></td>
</tr>
</table>
<!--mstheme--><font face="Arial, Helvetica"><!--mstheme--></font>

		 
		<table align="center" border="0" width="100%" height="30%">
		<tr>
		<th>Student Name</th>
			<th>Fee Date</th>
			<th>Fee Amount</th>
		</tr>
		<%
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con1=DriverManager.getConnection("jdbc:oracle:thin:@server:1521:server","edu","edu");
			Statement st1=con1.createStatement();
			Statement st2=con1.createStatement();
			String ss="select fee_payment_id,fee_date from FEE_PAYMENT_MASTER where student_id='"+session.getAttribute("StudentId")+"'";
			String ss1=null;
			java.sql.Date date=null;
			float amount=0.0f;
			System.out.println(ss);
			ResultSet rs1=st1.executeQuery(ss);				
			if(rs1.next())
			{
							ss1=rs1.getString(1);
							date=rs1.getDate(2);
			}
			ResultSet rs2=st2.executeQuery("select fee_amount from FEE_PAYMENT_MASTER_DATEILS where fee_payment_id='"+ss1+"'");
			if(rs2.next())
				amount=rs2.getFloat(1);
		%>
		<tr>
		
		          <td><div align="Center"><%=session.getAttribute("StudentName")%></div></td>
  		          <td><div align="Center"><%=date%></div></td>
  		          <td><div align="Center"><%=amount%></div></td>
		</tr>
		</table>
		
		</table>
	</body><%con1.close();%>

</html>